/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package GUI.NVQL;

import POJO.SanPhamBanTrongNgay;
import DAO.CTHoaDonDao;
import POJO.NhanVien;
import DAO.NhanVienDao;
import java.util.ArrayList;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
import GUI.Var;
import GUI.TOOL.XuatExcel;
import GUI.TOOL.ExcelOpener;
import java.io.File;
import java.io.IOException;
import java.util.Calendar;

/**
 *
 * @author Huê
 */
public class frLapBaoCaoBanHangTheoThang extends javax.swing.JInternalFrame {

	private DefaultTableModel tableModel;
	private DefaultComboBoxModel cbModel;
	private DefaultComboBoxModel cbModelNam;
	private DefaultComboBoxModel cbModelThang;
	private boolean load;
	private ArrayList<NhanVien> ds = new ArrayList<NhanVien>();

	private void loadNhanVien() {

		NhanVienDao dao = new NhanVienDao();

		ArrayList<NhanVien> ds = dao.layDanhSach();
		for (int i = 0; i < ds.size(); i++) {
			this.cbModel.addElement(ds.get(i));
		}
	}

	private void loadNam() {
		this.cbModelNam = new DefaultComboBoxModel();
		int nht = Var.NGAY.get(Calendar.YEAR);
		int from = nht - 10;
		int to = nht + 10;
		for (int i = from; i <= to; i++) {
			this.cbModelNam.addElement(i);
			if (i == nht) {
				this.cbModelNam.setSelectedItem(nht);
			}
		}
		jcbxNam.setModel(cbModelNam);
	}

	private void loadThang() {
		int tht = Var.NGAY.get(Calendar.MONTH);
		tht += 1;
		int thang = 12;
		for (int i = 1; i <= thang; i++) {
			this.cbModelThang.addElement(i);
			if (i == tht) {
				this.cbModelThang.setSelectedItem(tht);
			}
		}
	}

	public void DefaultTable1() {

		this.tableModel = new DefaultTableModel(); //tạo các cột

		this.tableModel.addColumn("STT ");
		this.tableModel.addColumn("Sản phẩm");
		this.tableModel.addColumn("Số lượng");
		this.tableModel.addColumn("Đơn giá");
		this.tableModel.addColumn("Thành tiền");

	}

	private void loadSanPham(int mnv, int thang, int nam) {
		int stt = 1;
		DefaultTable1();
		ArrayList<SanPhamBanTrongNgay> dsSanPham = CTHoaDonDao.layDanhSachMatHangDaBanTheoThang(mnv, thang, nam);

		for (SanPhamBanTrongNgay sp : dsSanPham) {
			Object[] items = new Object[]{
				stt,
				sp.getTenSP(),
				sp.getSl(),
				sp.getGia(),
				sp.getThanhTien()};
			tableModel.addRow(items);
			stt++;
		}
		jtbDSMHDaBan.setModel(tableModel);
		int[] va = {15, 30, 10, 20, 25};
		int[] pt = new int[5];
		for (int l = 0; l < 5; l++) {
			pt[l] = jtbDSMHDaBan.getWidth() * va[l] / 100;
			jtbDSMHDaBan.getColumnModel().getColumn(l).setPreferredWidth(pt[l]);
		}

	}

	/**
	 * Creates new form frLapBaoCaoBanHangTheoThang
	 */
	public frLapBaoCaoBanHangTheoThang() {
		initComponents();
		this.cbModel = new DefaultComboBoxModel();
		this.jcbxTenNhanVien.setModel(cbModel);
		this.tableModel = new DefaultTableModel();
		loadNhanVien();
		this.cbModelNam = new DefaultComboBoxModel();
		this.jcbxNam.setModel(cbModelNam);
		loadNam();
		this.cbModelThang = new DefaultComboBoxModel();
		this.jcbxThang.setModel(cbModelThang);
		loadThang();
	}

	/**
	 * This method is called from within the constructor to initialize the
	 * form. WARNING: Do NOT modify this code. The content of this method is
	 * always regenerated by the Form Editor.
	 */
	@SuppressWarnings("unchecked")
       // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
       private void initComponents() {

              jPanel1 = new javax.swing.JPanel();
              jLabel8 = new javax.swing.JLabel();
              jPanel2 = new javax.swing.JPanel();
              jbtnLapBaoCao = new javax.swing.JButton();
              jlbTenNV = new javax.swing.JLabel();
              jlbTenNhanVien = new javax.swing.JLabel();
              jButton1 = new javax.swing.JButton();
              jcbxTenNhanVien = new javax.swing.JComboBox();
              jlbTenNhanVien1 = new javax.swing.JLabel();
              jcbxThang = new javax.swing.JComboBox();
              jLabel3 = new javax.swing.JLabel();
              jcbxNam = new javax.swing.JComboBox();
              jPanel3 = new javax.swing.JPanel();
              jScrollPane1 = new javax.swing.JScrollPane();
              jtbDSMHDaBan = new javax.swing.JTable();
              jPanel5 = new javax.swing.JPanel();
              jlbTongTienDaBanTrongThang = new javax.swing.JLabel();
              jlbTongSSPDaBanTrongThang = new javax.swing.JLabel();
              jlbTongTienDaThuTrongThang = new javax.swing.JLabel();
              jlbTongTienChuaThuTrongThang = new javax.swing.JLabel();
              lbTSSPDB = new javax.swing.JLabel();
              lbTTDB = new javax.swing.JLabel();
              lbTTDT = new javax.swing.JLabel();
              lbCT = new javax.swing.JLabel();
              jLabel2 = new javax.swing.JLabel();
              jLabel4 = new javax.swing.JLabel();
              jLabel5 = new javax.swing.JLabel();

              setClosable(true);
              setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
              setIconifiable(true);
              setMaximizable(true);
              setResizable(true);

              jLabel8.setFont(new java.awt.Font("Tahoma", 0, 24)); // NOI18N
              jLabel8.setText("LẬP BÁO CÁO BÁN HÀNG TRONG THÁNG");

              javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
              jPanel1.setLayout(jPanel1Layout);
              jPanel1Layout.setHorizontalGroup(
                     jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                     .addGroup(jPanel1Layout.createSequentialGroup()
                            .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(jLabel8)
                            .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
              );
              jPanel1Layout.setVerticalGroup(
                     jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                     .addGroup(jPanel1Layout.createSequentialGroup()
                            .addContainerGap()
                            .addComponent(jLabel8)
                            .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
              );

              jbtnLapBaoCao.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
              jbtnLapBaoCao.setText("Lập báo cáo");
              jbtnLapBaoCao.setToolTipText("gọi lập phiếu nhập kho");
              jbtnLapBaoCao.addActionListener(new java.awt.event.ActionListener() {
                     public void actionPerformed(java.awt.event.ActionEvent evt) {
                            jbtnLapBaoCaoActionPerformed(evt);
                     }
              });

              jlbTenNhanVien.setText("Lọc theo nhân viên:");

              jButton1.setText("Lưu ra Excel");
              jButton1.addActionListener(new java.awt.event.ActionListener() {
                     public void actionPerformed(java.awt.event.ActionEvent evt) {
                            jButton1ActionPerformed(evt);
                     }
              });

              jcbxTenNhanVien.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "ALL", "Item 2", "Item 3", "Item 4" }));

              jlbTenNhanVien1.setText("Chọn tháng:");

              jcbxThang.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "[Chọn tháng]" }));

              jLabel3.setText("Chọn năm:");

              jcbxNam.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "[Chọn năm]" }));

              javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
              jPanel2.setLayout(jPanel2Layout);
              jPanel2Layout.setHorizontalGroup(
                     jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                     .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                   .addGroup(jPanel2Layout.createSequentialGroup()
                                          .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                                 .addGroup(jPanel2Layout.createSequentialGroup()
                                                        .addGap(153, 153, 153)
                                                        .addComponent(jlbTenNV)
                                                        .addGap(103, 103, 103))
                                                 .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
                                                        .addContainerGap()
                                                        .addComponent(jlbTenNhanVien)
                                                        .addGap(18, 18, 18)))
                                          .addComponent(jcbxTenNhanVien, javax.swing.GroupLayout.PREFERRED_SIZE, 199, javax.swing.GroupLayout.PREFERRED_SIZE))
                                   .addGroup(jPanel2Layout.createSequentialGroup()
                                          .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                                 .addComponent(jLabel3)
                                                 .addComponent(jlbTenNhanVien1))
                                          .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                                 .addGroup(jPanel2Layout.createSequentialGroup()
                                                        .addGap(18, 18, 18)
                                                        .addComponent(jcbxThang, 0, 199, Short.MAX_VALUE))
                                                 .addGroup(jPanel2Layout.createSequentialGroup()
                                                        .addGap(18, 18, 18)
                                                        .addComponent(jcbxNam, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))))
                            .addGap(72, 72, 72)
                            .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                   .addComponent(jbtnLapBaoCao)
                                   .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addContainerGap(48, Short.MAX_VALUE))
              );
              jPanel2Layout.setVerticalGroup(
                     jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                     .addGroup(jPanel2Layout.createSequentialGroup()
                            .addContainerGap()
                            .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                   .addGroup(jPanel2Layout.createSequentialGroup()
                                          .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                                 .addComponent(jcbxTenNhanVien, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                                 .addComponent(jlbTenNhanVien))
                                          .addGap(6, 6, 6)
                                          .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                                 .addComponent(jLabel3)
                                                 .addComponent(jcbxNam, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                                          .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                          .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                                 .addComponent(jlbTenNhanVien1, javax.swing.GroupLayout.PREFERRED_SIZE, 18, javax.swing.GroupLayout.PREFERRED_SIZE)
                                                 .addComponent(jcbxThang, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                                          .addGap(14, 14, 14))
                                   .addGroup(jPanel2Layout.createSequentialGroup()
                                          .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                                 .addComponent(jbtnLapBaoCao)
                                                 .addComponent(jlbTenNV))
                                          .addGap(18, 18, 18)
                                          .addComponent(jButton1)
                                          .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))))
              );

              jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder("Danh sách mặt hàng đã bán:"));
              jPanel3.setName(""); // NOI18N

              jtbDSMHDaBan.setModel(new javax.swing.table.DefaultTableModel(
                     new Object [][] {

                     },
                     new String [] {
                            "STT", "Sản phẩm", "Số lượng ", "Đơn giá", "Thành tiền"
                     }
              ));
              jScrollPane1.setViewportView(jtbDSMHDaBan);

              javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
              jPanel3.setLayout(jPanel3Layout);
              jPanel3Layout.setHorizontalGroup(
                     jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                     .addComponent(jScrollPane1)
              );
              jPanel3Layout.setVerticalGroup(
                     jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                     .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 264, Short.MAX_VALUE)
              );

              jlbTongTienDaBanTrongThang.setText("Tổng tiền đã bán:");

              jlbTongSSPDaBanTrongThang.setText("Tổng số sản phẩm đã bán:");

              jlbTongTienDaThuTrongThang.setText("Tổng tiền đã thu:");

              jlbTongTienChuaThuTrongThang.setText("Chưa thu:");

              lbTSSPDB.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
              lbTSSPDB.setText("0");

              lbTTDB.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
              lbTTDB.setText("0");

              lbTTDT.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
              lbTTDT.setText("0");

              lbCT.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
              lbCT.setText("0");

              jLabel2.setText("VNĐ");

              jLabel4.setText("VNĐ");

              jLabel5.setText("VNĐ");

              javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
              jPanel5.setLayout(jPanel5Layout);
              jPanel5Layout.setHorizontalGroup(
                     jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                     .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup()
                            .addContainerGap(52, Short.MAX_VALUE)
                            .addComponent(jlbTongSSPDaBanTrongThang)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(lbTSSPDB)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 53, Short.MAX_VALUE)
                            .addComponent(jlbTongTienDaBanTrongThang)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(lbTTDB)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jLabel5)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 18, Short.MAX_VALUE)
                            .addComponent(jlbTongTienDaThuTrongThang)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(lbTTDT)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(jLabel4)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 18, Short.MAX_VALUE)
                            .addComponent(jlbTongTienChuaThuTrongThang)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(lbCT)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jLabel2)
                            .addContainerGap(52, Short.MAX_VALUE))
              );
              jPanel5Layout.setVerticalGroup(
                     jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                     .addGroup(jPanel5Layout.createSequentialGroup()
                            .addContainerGap()
                            .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                                   .addComponent(jlbTongTienDaBanTrongThang)
                                   .addComponent(jlbTongSSPDaBanTrongThang)
                                   .addComponent(jlbTongTienDaThuTrongThang)
                                   .addComponent(jlbTongTienChuaThuTrongThang)
                                   .addComponent(lbTSSPDB)
                                   .addComponent(lbTTDB)
                                   .addComponent(lbTTDT)
                                   .addComponent(lbCT)
                                   .addComponent(jLabel2)
                                   .addComponent(jLabel4)
                                   .addComponent(jLabel5))
                            .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
              );

              javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
              getContentPane().setLayout(layout);
              layout.setHorizontalGroup(
                     layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                     .addGroup(layout.createSequentialGroup()
                            .addGap(0, 0, 0)
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                   .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                   .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                   .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                   .addComponent(jPanel5, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
              );
              layout.setVerticalGroup(
                     layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                     .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                            .addGap(0, 0, 0)
                            .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(0, 0, 0)
                            .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(0, 0, 0)
                            .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addGap(0, 0, 0)
                            .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(0, 0, 0))
              );

              pack();
       }// </editor-fold>//GEN-END:initComponents

       private void jbtnLapBaoCaoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtnLapBaoCaoActionPerformed
		// TODO add your handling code here:
		int mnv = ((NhanVien) jcbxTenNhanVien.getSelectedItem()).getMaNV();
		int nam = (Integer.parseInt(jcbxNam.getSelectedItem().toString()));
		int thang = (Integer.parseInt(jcbxThang.getSelectedItem().toString()));
		loadSanPham(mnv, thang, nam);
		double tongsospdaban = CTHoaDonDao.TongSanPhamDaBanTrongThang(mnv, thang, nam);
		lbTSSPDB.setText(String.valueOf(tongsospdaban));
		double tongtiendaban = CTHoaDonDao.TongTienDaBanTrongThang(mnv, thang, nam);
		lbTTDB.setText(String.valueOf(tongtiendaban));
		double tongtiendathu = CTHoaDonDao.TongTienDaThuTrongThang(mnv, thang, nam);
		lbTTDT.setText(String.valueOf(tongtiendathu));
		double tongtienchuathu = tongtiendaban - tongtiendathu;
		lbCT.setText(String.valueOf(tongtienchuathu));
       }//GEN-LAST:event_jbtnLapBaoCaoActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
	    // TODO add your handling code here:
	    try {
//     Note that i'm actually saving the file first
		    XuatExcel exp = new XuatExcel();
		    File file = new File("BaoCaoBanHangTrongThang.xls");
		    exp.exportTable(jtbDSMHDaBan, file);
		    ExcelOpener opn = new ExcelOpener();
		    opn.openTable(file);
	    } catch (IOException ex) {
		    System.out.println(ex.getMessage());
		    ex.printStackTrace();
	    }

    }//GEN-LAST:event_jButton1ActionPerformed
       // Variables declaration - do not modify//GEN-BEGIN:variables
       private javax.swing.JButton jButton1;
       private javax.swing.JLabel jLabel2;
       private javax.swing.JLabel jLabel3;
       private javax.swing.JLabel jLabel4;
       private javax.swing.JLabel jLabel5;
       private javax.swing.JLabel jLabel8;
       private javax.swing.JPanel jPanel1;
       private javax.swing.JPanel jPanel2;
       private javax.swing.JPanel jPanel3;
       private javax.swing.JPanel jPanel5;
       private javax.swing.JScrollPane jScrollPane1;
       private javax.swing.JButton jbtnLapBaoCao;
       private javax.swing.JComboBox jcbxNam;
       private javax.swing.JComboBox jcbxTenNhanVien;
       private javax.swing.JComboBox jcbxThang;
       private javax.swing.JLabel jlbTenNV;
       private javax.swing.JLabel jlbTenNhanVien;
       private javax.swing.JLabel jlbTenNhanVien1;
       private javax.swing.JLabel jlbTongSSPDaBanTrongThang;
       private javax.swing.JLabel jlbTongTienChuaThuTrongThang;
       private javax.swing.JLabel jlbTongTienDaBanTrongThang;
       private javax.swing.JLabel jlbTongTienDaThuTrongThang;
       private javax.swing.JTable jtbDSMHDaBan;
       private javax.swing.JLabel lbCT;
       private javax.swing.JLabel lbTSSPDB;
       private javax.swing.JLabel lbTTDB;
       private javax.swing.JLabel lbTTDT;
       // End of variables declaration//GEN-END:variables
}
